SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[test] 
	-- Add the parameters for the stored procedure here
	(
	@param_survey INT
)

AS
	CREATE TABLE #temp_table
	(
	item INT,
	question NVARCHAR(200),
	option1 FLOAT,
	option2 FLOAT,
	option3 FLOAT,
	option4 FLOAT,
	option5 FLOAT,
	option6 FLOAT
	)
	Declare cur Cursor for 
	SELECT item,question,selected 
	FROM dbo.JOL_SurveyManagement_Respond,dbo.JOL_SurveyManagement_Items
	WHERE item=dbo.JOL_SurveyManagement_Items.id AND survey=@param_survey
	
	
GO
